package com.dingding.special.user.account.sql;

/**
 * 
 * @ClassName: UserAccountSQL 
 * @Description: 用户账户SQL类
 * @author YHQ
 * @date 2016年8月19日 下午4:09:04
 * @since V2.4.0
 * 
 */
public class UserAccountSQL {

	/**
	 * 获取用户钱包
	 */
	public static String GET_USER_PACKET = "SELECT s.currencyAmount,ul.depositNumber,ul.isDeposit FROM specialuseraccount s INNER JOIN specialuserlogin ul ON s.userId = ul.suid WHERE s.userId = ?";
	
	/**
	 * 获取用户账户收支明细
	 */
	public static String INCOME_AND_EXPENSESLIST = "SELECT s.tradeMoney,s.tradeTime FROM specialaccounttradedetail s WHERE s.userId = ? ORDER BY s.tradeTime DESC LIMIT ?,?";
	
}
